Select * from [Address] where convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [CompanyId]) + ‘-‘ + convert(varchar, [PersonId]) + ‘-‘ + [Name] + ‘-‘ + convert(varchar, [AddressTypeId]) + ‘-‘ + Format([StartDate], ‘yyyyMMdd’) in (Select convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [CompanyId]) + ‘-‘ + convert(varchar, [PersonId]) + ‘-‘ + [Name] + ‘-‘ + convert(varchar, [AddressTypeId]) + … Continue reading Query Address LPrimaryKey